How to fetch same record from two table in SQL Server?
How to fetch same record from two table in SQL Server?
93018-Nov-2021
Updated on 18-Nov-2021
Home / DeveloperSection / Forums / How to fetch same record from two table in SQL Server?
How to fetch same record from two table in SQL Server?
Ashutosh Kumar Verma
18-Nov-2021Fetch same Record from Two table:
The INTERSECT Operator is used to find the same record from two database in SQL Server.
Let us create two table Employees and Manager
Employees table:
Manager table:
Now, the following SQL statement is find the same record from above both table by using INTERSECT Clause,
Output: